﻿CREATE TABLE [dbo].[Potential] (
    [PotentialKey] INT      IDENTITY (1, 1) NOT NULL,
    [OrgKey]       INT      DEFAULT ((0)) NULL,
    [ProduktKey]   INT      DEFAULT ((0)) NULL,
    [Menge]        SMALLINT DEFAULT ((0)) NULL,
    CONSTRAINT [aaaaaPotential_PK] PRIMARY KEY NONCLUSTERED ([PotentialKey] ASC)
);


GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'0', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential';


GO
EXECUTE sp_addextendedproperty @name = N'DateCreated', @value = N'96-03-09 14:40:14', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential';


GO
EXECUTE sp_addextendedproperty @name = N'LastUpdated', @value = N'03-04-17 21:06:50', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential';


GO
EXECUTE sp_addextendedproperty @name = N'MS_OrderByOn', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'Potential', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential';


GO
EXECUTE sp_addextendedproperty @name = N'RecordCount', @value = N'0', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential';


GO
EXECUTE sp_addextendedproperty @name = N'Updatable', @value = N'True', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential';


GO
EXECUTE sp_addextendedproperty @name = N'AllowZeroLength', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'PotentialKey';


GO
EXECUTE sp_addextendedproperty @name = N'AppendOnly', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'PotentialKey';


GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'17', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'PotentialKey';


GO
EXECUTE sp_addextendedproperty @name = N'CollatingOrder', @value = N'1033', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'PotentialKey';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnHidden', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'PotentialKey';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnOrder', @value = N'0', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'PotentialKey';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnWidth', @value = N'-1', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'PotentialKey';


GO
EXECUTE sp_addextendedproperty @name = N'DataUpdatable', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'PotentialKey';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Eindeutige Kennung für Potential', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'PotentialKey';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'PotentialKey', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'PotentialKey';


GO
EXECUTE sp_addextendedproperty @name = N'OrdinalPosition', @value = N'1', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'PotentialKey';


GO
EXECUTE sp_addextendedproperty @name = N'Required', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'PotentialKey';


GO
EXECUTE sp_addextendedproperty @name = N'Size', @value = N'4', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'PotentialKey';


GO
EXECUTE sp_addextendedproperty @name = N'SourceField', @value = N'PotentialKey', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'PotentialKey';


GO
EXECUTE sp_addextendedproperty @name = N'SourceTable', @value = N'Potential', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'PotentialKey';


GO
EXECUTE sp_addextendedproperty @name = N'Type', @value = N'4', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'PotentialKey';


GO
EXECUTE sp_addextendedproperty @name = N'AllowZeroLength', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'OrgKey';


GO
EXECUTE sp_addextendedproperty @name = N'AppendOnly', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'OrgKey';


GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'1', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'OrgKey';


GO
EXECUTE sp_addextendedproperty @name = N'CollatingOrder', @value = N'1033', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'OrgKey';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnHidden', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'OrgKey';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnOrder', @value = N'0', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'OrgKey';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnWidth', @value = N'-1', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'OrgKey';


GO
EXECUTE sp_addextendedproperty @name = N'DataUpdatable', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'OrgKey';


GO
EXECUTE sp_addextendedproperty @name = N'DefaultValue', @value = N'0', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'OrgKey';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DecimalPlaces', @value = N'255', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'OrgKey';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'OrganisationsKey - Verweis auf Tabelle-Organisation', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'OrgKey';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DisplayControl', @value = N'109', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'OrgKey';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'OrgKey', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'OrgKey';


GO
EXECUTE sp_addextendedproperty @name = N'OrdinalPosition', @value = N'2', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'OrgKey';


GO
EXECUTE sp_addextendedproperty @name = N'Required', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'OrgKey';


GO
EXECUTE sp_addextendedproperty @name = N'Size', @value = N'4', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'OrgKey';


GO
EXECUTE sp_addextendedproperty @name = N'SourceField', @value = N'OrgKey', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'OrgKey';


GO
EXECUTE sp_addextendedproperty @name = N'SourceTable', @value = N'Potential', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'OrgKey';


GO
EXECUTE sp_addextendedproperty @name = N'Type', @value = N'4', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'OrgKey';


GO
EXECUTE sp_addextendedproperty @name = N'AllowZeroLength', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'ProduktKey';


GO
EXECUTE sp_addextendedproperty @name = N'AppendOnly', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'ProduktKey';


GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'1', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'ProduktKey';


GO
EXECUTE sp_addextendedproperty @name = N'CollatingOrder', @value = N'1033', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'ProduktKey';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnHidden', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'ProduktKey';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnOrder', @value = N'0', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'ProduktKey';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnWidth', @value = N'-1', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'ProduktKey';


GO
EXECUTE sp_addextendedproperty @name = N'DataUpdatable', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'ProduktKey';


GO
EXECUTE sp_addextendedproperty @name = N'DefaultValue', @value = N'0', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'ProduktKey';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DecimalPlaces', @value = N'255', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'ProduktKey';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'ProduktKey - Verweis auf Tabelle-Produkt', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'ProduktKey';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DisplayControl', @value = N'109', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'ProduktKey';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'ProduktKey', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'ProduktKey';


GO
EXECUTE sp_addextendedproperty @name = N'OrdinalPosition', @value = N'3', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'ProduktKey';


GO
EXECUTE sp_addextendedproperty @name = N'Required', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'ProduktKey';


GO
EXECUTE sp_addextendedproperty @name = N'Size', @value = N'4', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'ProduktKey';


GO
EXECUTE sp_addextendedproperty @name = N'SourceField', @value = N'ProduktKey', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'ProduktKey';


GO
EXECUTE sp_addextendedproperty @name = N'SourceTable', @value = N'Potential', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'ProduktKey';


GO
EXECUTE sp_addextendedproperty @name = N'Type', @value = N'4', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'ProduktKey';


GO
EXECUTE sp_addextendedproperty @name = N'AllowZeroLength', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'Menge';


GO
EXECUTE sp_addextendedproperty @name = N'AppendOnly', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'Menge';


GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'1', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'Menge';


GO
EXECUTE sp_addextendedproperty @name = N'CollatingOrder', @value = N'1033', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'Menge';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnHidden', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'Menge';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnOrder', @value = N'0', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'Menge';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnWidth', @value = N'-1', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'Menge';


GO
EXECUTE sp_addextendedproperty @name = N'DataUpdatable', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'Menge';


GO
EXECUTE sp_addextendedproperty @name = N'DefaultValue', @value = N'0', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'Menge';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DecimalPlaces', @value = N'255', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'Menge';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Menge', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'Menge';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DisplayControl', @value = N'109', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'Menge';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'Menge', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'Menge';


GO
EXECUTE sp_addextendedproperty @name = N'OrdinalPosition', @value = N'4', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'Menge';


GO
EXECUTE sp_addextendedproperty @name = N'Required', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'Menge';


GO
EXECUTE sp_addextendedproperty @name = N'Size', @value = N'2', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'Menge';


GO
EXECUTE sp_addextendedproperty @name = N'SourceField', @value = N'Menge', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'Menge';


GO
EXECUTE sp_addextendedproperty @name = N'SourceTable', @value = N'Potential', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'Menge';


GO
EXECUTE sp_addextendedproperty @name = N'Type', @value = N'3', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Potential', @level2type = N'COLUMN', @level2name = N'Menge';

